home *** CD-ROM | disk | FTP | other *** search
/ Reverse Code Engineering RCE CD +sandman 2000 / ReverseCodeEngineeringRceCdsandman2000.iso / RCE / Ebooks / Database C++4 / 08vcg03.gif < prev    next >
Graphics Interchange Format  |  2000-05-25  |  21.3 KB  |  356x269  |  8-bit (163 colors)
   ocr: Execute SQL X SQL Statement Execute SELECT Categories. "Category ID"AS Cat, (fn MONTHUrders-Urder Date")AS Cancel Month, Sum("Order Details"."Unit Price" * "Order Details".QuantityAS Sales FROM Categories, "Order Details", - Orders, Open... Products WHERE Products. "Category ID" = Categonies."Category ID" AND "Urder Save... Details"."Order ID" == Orders. "Order ID" AND "Order Details"."Product ID" == Products."Product ID" GROUP BY Categories." "Category ID".fn rocedures.. MONTH(Orders." "Order Date")) Data Sources... Crosstab. Database: